package com.ruoyi.stat.evaluate.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.ruoyi.api.dto.evaluate.EnvironmentTypeScoreDto;
import com.ruoyi.api.dto.evaluate.EnvironmentYearStatDto;
import com.ruoyi.common.core.mapper.BaseMapperPlus;
import com.ruoyi.stat.evaluate.domain.EvaluateStat;
import com.ruoyi.stat.evaluate.domain.vo.EvaluateStatVo;

/**
 * 市环境测评数据统计汇总Mapper接口
 *
 * @author cc
 * @date 2023-04-28
 */
public interface EvaluateStatMapper extends BaseMapperPlus<EvaluateStatMapper, EvaluateStat, EvaluateStatVo> {
	int createStatDate(@Param("startTime") String startTime , @Param("endTime") String endTime);
	
	List<EnvironmentTypeScoreDto> getEnvironmentTypeScoreDtoList(@Param(Constants.WRAPPER) Wrapper<EvaluateStat> queryWrapper);
	
	String getAvgScore(@Param(Constants.WRAPPER) Wrapper<EvaluateStat> queryWrapper);
	
	List<EnvironmentYearStatDto> getEnvironmentYearStatDtoList(@Param(Constants.WRAPPER) Wrapper<EvaluateStat> queryWrapper);
}
